Project Overview
This project explores the application of Monte Carlo simulations in two key domains: cost estimation for construction projects and strategic investment allocation. By simulating various outcomes under uncertainty, the project provides actionable insights for decision-making.
Key Outcomes
- Construction Cost Estimation: Developed a probabilistic model to estimate costs, ensuring adequate contingency funds under uncertain conditions.
- Investment Allocation: Created a simulation to evaluate risk-return trade-offs for portfolio decisions, optimizing allocation strategies over a 10-year horizon.
Tools Used
- Microsoft Excel
- Macros
- Conditional Formatting
Download the Answer Files
Click the links below to download the Excel files containing the project details and insights:
Download Problem 1 Answer File Download Problem 2 Answer File
